use Sample
GO

CREATE TABLE tblEmployee (
Id int PRIMARY KEY,
Name nvarchar(50),
Salary int,
Gender nvarchar(10),
City nvarchar(50)
)

Execute sp_helpindex tblEmployee

Insert into tblEmployee values(3,'John',4500,'Male','New York')
Insert into tblEmployee values(1,'Sam',2500,'Male','Lon Don')
Insert into tblEmployee values(4,'Sara',5500,'FeMale','Tokyo')
Insert into tblEmployee values(5,'Todd',3100,'Male','Torento')
Insert into tblEmployee values(2,'Pam',6500,'FeMale','Sydney')

select * from tblEmployee

create clustered index IX_tblEmployee_Gender_Salary on tblEmployee(Gender DESC, Salary ASC)
			